SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+free +local +advertising +sites' IN BOOLEAN MODE)) AND iCityID IN (6935,6902,16187,16608,6918,16153,6959,6896,6939,6996,6940,16161,6929,6915,6950,6926,6947,6968,6962,6954,12444,16160,6951,16155,6970,12403,16154,6916,13015,12421,6910,16165,16189,12405,13039,6883,6927,10506,12420,16233,6976,13038,10949,10716,10948,10988,12408,16162,7012,6956,10794,6907,7009,6909,6884,10981,6919,10177,16157,10922,16208,6914,6928,6988,10387,10797,7001,6921,16579,16156,16590,6848,6903,10254,12428,12423,10357,6853,6876,16174,6960,6924,12410,6879,6985,11071,6856,6866,12416,10785,12427,10681,12426,6941,6899,6913,12430,11026,10980,10628,6898,6920,10953,13033,16186,10585,7008,16164,10793,12443,6997,6993,12417,6922,12422,12414,6944,10185,6885,6911,6967,6963,6938,10519,6886,6978,6931,10442,6905,6904,12429,6977,10899,12432,6858,6892,12442,6983,13037,16188,6934,6991,10202,16173,7003,10398,12425,13029,7004,7013,16644,10900,12409,6982,6943,13032,6957,12411,12424,6895,12418,10280,12434,11103,6961,6964,6975,11102,7019,7017,12436,12431,12419,11052,16225,12437,7014,12438,6952,8115,12406,6981,12404,7016,8170,13031,12415,10409,8359,6906,12439,10402,12441,10669,8351,8323,6893) ORDER BY FIELD(iCityID, 6935,6902,16187,16608,6918,16153,6959,6896,6939,6996,6940,16161,6929,6915,6950,6926,6947,6968,6962,6954,12444,16160,6951,16155,6970,12403,16154,6916,13015,12421,6910,16165,16189,12405,13039,6883,6927,10506,12420,16233,6976,13038,10949,10716,10948,10988,12408,16162,7012,6956,10794,6907,7009,6909,6884,10981,6919,10177,16157,10922,16208,6914,6928,6988,10387,10797,7001,6921,16579,16156,16590,6848,6903,10254,12428,12423,10357,6853,6876,16174,6960,6924,12410,6879,6985,11071,6856,6866,12416,10785,12427,10681,12426,6941,6899,6913,12430,11026,10980,10628,6898,6920,10953,13033,16186,10585,7008,16164,10793,12443,6997,6993,12417,6922,12422,12414,6944,10185,6885,6911,6967,6963,6938,10519,6886,6978,6931,10442,6905,6904,12429,6977,10899,12432,6858,6892,12442,6983,13037,16188,6934,6991,10202,16173,7003,10398,12425,13029,7004,7013,16644,10900,12409,6982,6943,13032,6957,12411,12424,6895,12418,10280,12434,11103,6961,6964,6975,11102,7019,7017,12436,12431,12419,11052,16225,12437,7014,12438,6952,8115,12406,6981,12404,7016,8170,13031,12415,10409,8359,6906,12439,10402,12441,10669,8351,8323,6893) ASC, p.tmPosted DESC LIMIT 24
free local advertising sites, Community Classifieds, Local Events, Friends, Activities in New London
